Remove Duplicate Range
AutomatR.Excel.Activities.RemoveDuplicateRange
The "Remove Duplicate Range" activity in AutomatR is part of the Excel activities package, designed to delete all rows that are duplicates within a specified range. This activity aids in data cleansing by removing redundant information based on the defined criteria within the given Excel range.
Properties
| Name | Description |
|---|---|
| Input | |
| Range | Enter the range from which duplicate rows need to be removed. String variables containing the range specification (e.g., "A1:C10"). |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Enter the wait time in seconds (Example: 5 seconds i.e., 5) to start the activity. Integer variables containing the delay duration. |
How to use:
- Drag and drop the "Remove Duplicate Range" activity onto the workflow.
- Configure the properties by specifying the range from which duplicate rows should be removed.
- Optionally, configure the delay.
- Execute the workflow to delete duplicate rows within the specified Excel range.
Example: Consider an example where the "Remove Duplicate Range" activity is used to remove duplicate rows within the range "A2:C20" in an Excel workbook:
Remove Duplicate Range:
Range: "A2:C20"
In this example, the activity deletes all rows within the specified range that are duplicates based on the entire row's content.
Note: Ensure that the specified range is valid; otherwise, the activity will raise an exception indicating an invalid range.
Important:
- The activity considers entire row content for identifying duplicates within the specified range.
- Be cautious while using this activity, as it permanently removes rows from the Excel sheet.